SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_AddRecruitPosition]
	
	(
	@param_participants_apply INT,
	@param_position NVARCHAR(50),
	@param_target NVARCHAR(50),
	@param_work_area NVARCHAR(50),
	@param_work_city NVARCHAR(50),
	@param_quantity INT,
	@param_professional NVARCHAR(50),
	@param_degree NVARCHAR(50),
	@param_description NVARCHAR(MAX),
	@param_remark NVARCHAR(MAX),
	@param_add_time SMALLDATETIME,
	@param_user_add NVARCHAR(50),
	@param_state bit
	
	)
AS
	/* SET NOCOUNT ON */
	INSERT INTO dbo.JOL_Recruitment_Position
	        ( participants_apply ,
	          position ,
	          target ,
	          work_area ,
	          work_city ,
	          quantity ,
	          professional ,
	          degree ,
	          description ,
	          visit_times ,
	          remark ,
	          add_time ,
	          user_add ,
	          current_stage ,
	          state
	        )
	VALUES  ( @param_participants_apply , -- participants_apply - int
	          @param_position , -- position - nvarchar(50)
	          @param_target , -- taget - nvarchar(50)
	          @param_work_area , -- work_area - nvarchar(50)
	          @param_work_city , -- work_city - nvarchar(50)
	          @param_quantity, -- quantity - int
	          @param_professional , -- professional - nvarchar(50)
	          @param_degree , -- degree - nvarchar(50)
	          @param_description , -- description - nvarchar(max)
	          0 , -- visit_times - int
	          @param_remark , -- remark - nvarchar(max)
	          @param_add_time , -- add_time - smalldatetime
	          @param_user_add , -- user_add - nvarchar(50)
	          1 , -- current_stage - int
	          @param_state  -- state - bit
	        )
	
	
	RETURN

GO
